Aside

logo

Contact

Programming and Visualization Skills

R
Python
SQL
Tableau
Power BI

Open Source Contributions

All projects available at github.com/nstrayer/<name>

More info

See full CV for more complete list of positions and publications.

Disclaimer

Made w/ pagedown.

Source code: github.com/nstrayer/cv.

Last updated on 2022-02-19.

Main

Megan Rowland

I am currently an Analytics Developer who is seeking to further my education by completing Master’s of Program Evaluation and Data Analytics.

Looking for a data science position to use my newly acquired skills in the environmental industry.

Education

Masters of Program Evaluation and Data Analytics

Tempe, AZ

Arizona State University

2022 - 2021

B.S., Accountancy (minor Data Analytics)

Tempe, AZ

Arizona State University

2017 - 2014

Selected Positions

Analytics Developer

Phoenix, AZ

Salt River Project

Present - 2020

  • Create Tableau or Power BI dashboards for company-wide use primarily through SQL and Python querying to automate reports. Worked with departments across the organization to create custom data visualizations to enable further analysis and actionable intelligence out of large datasets. Use of Tableau, Power Bi, SAS, SQL, and Python. Regularly present to executive management to demo findings.
  • Work primarily done in R, Javascript, and Adobe Illustrator.

Rotational Business Analyst

Phoenix, AZ

Salt River Project

2020 - 2019

  • Power Generation Services: learned power plant operations, technology, and terminology. Created and instructed the use of a standardized Budget template across generation analysts. Resource Analysis & Planning: Performed coal and nuclear asset evaluation of environmental impacts, desired life of plant, and net present value of maintaining or acquiring resources while aligning with corporate goals. Used Aurora modeling tool, SQL, and Excel in post processing of model runs to calculate financial impact and propose best economic case. Analytics Center of Excellence: Through multi-departmental collaboration, validated and combined numerous sources of data and subsequently created one source of generation related data in Tableau for executive management. Learned Python and became familiar with Data Science principles. Operations Planning: produced Daily Market Summary report that details company financial performance in participating markets. Created data visualization to compare forecasts related to temperature, humidity, and load to actual figures to determine the most accurate. Completed battery performance analysis with considerations to load, solar production, and LMP.
  • Constructed training protocol for bringing third parties up to speed with new protocol.

Audit Intern

Phoenix, AZ

KPMG

2018

  • Worked busy season with KPMG in their audit practice to assist with cash, debt, receivables, and legal detail testing. Worked closely with the customer to understand their industry and ensure SEC compliance. Tied-out client financial statements and disclosures.

Program Finance Analyst

Scottsdale, AZ

General Dynamics

2018

  • Managed contracts and funding for over $200 million Top Secret programs. Provided support to program teams, requested additional funds, completed invoices, enforced government compliance. Forecasted sales, earnings, and direct costs related to programs quarterly. Performed month-end closing activities including variance reporting with Financial Planning.

Information Technology Intern

Phoenix, AZ

Salt River Project

2017 - 2016

  • Created and managed SharePoint forms using Microsoft InfoPath and SharePoint Designer, archived databases, managed metadata on databases. Created virtualized applications for remote desktop users through Citrix platform.

Selected Writing